# 30日内每个用户的最大连续活跃天数
/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/jtp_app_report?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table  user_activity_continue_report \
--update-key "dt,device_id" \
--export-dir /user/spark/warehouse/jtp_app_ads/ads_user_activity_continue_report \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
--num-mappers 1 \
--input-null-string '\\N' \
--input-null-non-string '\\N'

# 30日内用户连续活跃天数不同区间人数
/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/jtp_app_report?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table  user_activity_continue_count_report \
--update-key "dt" \
--export-dir /user/spark/warehouse/jtp_app_ads/ads_user_activity_continue_count_report \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
--num-mappers 1 \
--input-null-string '\\N' \
--input-null-non-string '\\N'

# 30日内不同用户沉默天数区间统计人数
/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/jtp_app_report?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table  user_silent_count_report \
--update-key "dt" \
--export-dir /user/spark/warehouse/jtp_app_ads/ads_user_silent_count_report \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
--num-mappers 1 \
--input-null-string '\\N' \
--input-null-non-string '\\N'